Purchasing Receipt Work (POP10300)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt Work (POP10300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/POP10300

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: Purchasing Receipt Work
Physical Name: POP10300
Technical Name: POP_Receipt

Group Display Name: Purchasing Transactions
Group Technical Name: Purchasing Transactions

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	POPRCTNM	POP Receipt Number	String	STR17_POP_Number	17
2	POPTYPE	POP Type	Integer	DDL_POP_Type	0
3	VNDDOCNM	Vendor Document Number	String	STR20_Document_Number	20
4	receiptdate	Receipt Date	Date	DT	8
5	GLPOSTDT	GL Posting Date	Date	DT	8
6	ACTLSHIP	Actual Ship Date	Date	DT	8
7	BCHSOURC	Batch Source	String	STR15	15
	Records whether the transaction was entered in a batch or not. Click to show/hide the Batch Sources PM_Trxent Batch XXPM_Trxent No batch (real-time)
8	BACHNUMB	Batch Number	String	STR15_LBAU	15
9	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Purchasing Receipt Work'].VENDORID AS 'Purchasing Receipt Work-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Purchasing Receipt Work'].VENDORID = ['PM Vendor Master File'].VENDORID
10	VENDNAME	Vendor Name	String	STR64_Vendor_Name	64
11	SUBTOTAL	Subtotal	Currency	DLR17_RBS0_STR$	17
12	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
13	TRDPCTPR	Trade Discount Percent (Precise)	Currency (Variable)	Trade Discount Percent (Precise)	23
14	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
15	MISCAMNT	Misc Amount	Currency	DLR17_RBS0_UTR$	17
16	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
17	TEN99AMNT	1099 Amount	Currency	DLR17_RBS0_UTR$	17
18	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['Purchasing Receipt Work'].PYMTRMID AS 'Purchasing Receipt Work-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['Purchasing Receipt Work'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
19	DSCPCTAM	Discount Percent Amount	Integer	INT5_%2	5
20	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
21	DISAVAMT	Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
22	DISCDATE	Discount Date	Date	DT	8
23	DUEDATE	Due Date	Date	DT	8
24	REFRENCE	Reference	String	STR30	30
25	RCPTNOTE	Receipt Note ID Array	DLR14	Currency	14
26	RCPTNOTE_1	Receipt Note ID Array[1]	Currency	DLR14	14
27	RCPTNOTE_2	Receipt Note ID Array[2]	Currency	DLR14	14
28	RCPTNOTE_3	Receipt Note ID Array[3]	Currency	DLR14	14
29	RCPTNOTE_4	Receipt Note ID Array[4]	Currency	DLR14	14
30	RCPTNOTE_5	Receipt Note ID Array[5]	Currency	DLR14	14
31	RCPTNOTE_6	Receipt Note ID Array[6]	Currency	DLR14	14
32	RCPTNOTE_7	Receipt Note ID Array[7]	Currency	DLR14	14
33	RCPTNOTE_8	Receipt Note ID Array[8]	Currency	DLR14	14
34	POPHDR1	POP HDR Errors 1	Long Integer	ML_POP_HDR_Errors_1	0
35	POPHDR2	POP HDR Errors 2	Long Integer	ML_POP_HDR_Errors_2	0
36	POPLNERR	POP LINE Errors	Long Integer	ML_POP_LINE_Errors	0
37	POSTEDDT	Posted Date	Date	DATE	6
38	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchasing Receipt Work'].PTDUSRID AS 'Purchasing Receipt Work-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchasing Receipt Work'].PTDUSRID = ['Users Master'].USERID
39	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Purchasing Receipt Work'].USER2ENT AS 'Purchasing Receipt Work-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Purchasing Receipt Work'].USER2ENT = ['Users Master'].USERID
40	CREATDDT	Created Date	Date	DT	8
41	MODIFDT	Modified Date	Date	DT	8
42	TRXSORCE	TRX Source	String	STR13	13
43	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
	Partial key to the PM Key Master File (PM00400). Click to show/hide SELECT ['Purchasing Receipt Work'].VCHRNMBR AS 'Purchasing Receipt Work-Voucher Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['Purchasing Receipt Work'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM AND ['Purchasing Receipt Work'].DOCTYPE = ['PM Key Master File'].DOCTYPE
44	Tax_Date	Tax Date	Date	DT	8
45	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt Work'].CURNCYID AS 'Purchasing Receipt Work-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt Work'].CURNCYID = ['Currency Setup'].CURNCYID
46	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['Purchasing Receipt Work'].CURRNIDX AS 'Purchasing Receipt Work-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['Purchasing Receipt Work'].CURRNIDX = ['Currency Setup'].CURRNIDX
47	RATETPID	Rate Type ID	String	STR15_Rate_Type_ID	15
	Key to the Multicurrency Rate Type Setup (MC40100). Click to show/hide SELECT ['Purchasing Receipt Work'].RATETPID AS 'Purchasing Receipt Work-Rate Type ID' ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN MC40100 AS ['Multicurrency Rate Type Setup'] ON ['Purchasing Receipt Work'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
48	EXGTBLID	Exchange Table ID	String	STR15_Exchange_Table_ID	15
	Key to the Multicurrency Exchange Rate Maintenance (MC00100). Click to show/hide SELECT ['Purchasing Receipt Work'].EXGTBLID AS 'Purchasing Receipt Work-Exchange Table ID' ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance'] ON ['Purchasing Receipt Work'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
49	XCHGRATE	Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
50	EXCHDATE	Exchange Date	Date	DT_Date	6
51	TIME1	Time	Time	TM6	6
52	RATECALC	Rate Calc Method	Integer	INT	0
	Rate Calc Method of the transaction. For non multi-currency transactions, this field will be blank. Click to show/hide Rate Calc Methods 0 Multiply 1 Divide
53	DENXRATE	Denomination Exchange Rate	Currency (Variable)	DLR14_Exchange_Rate	14
54	MCTRXSTT	MC Transaction State	Integer	INT1	1
	MC Transaction State of the transaction. State the transaction was created in. For non multi-currency transactions, this field will be blank. Click to show/hide MC Transaction States 0 Euro currency is not created or no denomination currencies are enabled. 1 Originating is not a denomination; Functional is not a denomination 2 Originating is not a denomination; Functional is the Euro currency. 3 Originating is not a denomination; Functional is a denomination. 4 Originating is a denomination; Functional is not a denomination. 5 Originating is a denomination; Functional is a denomination. 6 Originating is a denomination; Functional is the Euro currency. 7 Originating is the Euro currency; Functional is a denomination. 8 Originating is the Euro currency; Functional is not a denomination.
55	ORSUBTOT	Originating Subtotal	Currency	DLR17_RBS0_STR$	17
56	ORTDISAM	Originating Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
57	ORFRTAMT	Originating Freight Amount	Currency	DLR17_RBS0_UTR$	17
58	ORMISCAMT	Originating Misc Amount	Currency	DLR19_RBSO_UTR$	19
59	ORTAXAMT	Originating Tax Amount	Currency	DLR17_RBS0_UTR$	17
60	OR1099AM	Originating 1099 Amount	Currency	DLR17_RBS0_UTR$	17
61	ORDDLRAT	Originating Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
62	ORDAVAMT	Originating Discount Available Amount	Currency	DLR17_RBS0_UTR$	17
63	WITHHAMT	Withholding Amount	Currency	DLR19_RBSO_UTR$	19
64	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
65	BNKRCAMT	Bank Receipts Amount	Currency	DLR17_RBS0_STR$	17
66	ECTRX	EC Transaction	Boolean	CB_EC_Transaction	0
	The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction. Click to show/hide Document Printed flag 0 Not an EU Transaction. 1 EU Transaction.
67	TXRGNNUM	Tax Registration Number	String	STR25	25
68	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt Work'].TAXSCHID AS 'Purchasing Receipt Work-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt Work'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
69	TXENGCLD	Tax Engine Called	Boolean	YN	0
70	BSIVCTTL	Based On Invoice Total	Boolean	YN	0
71	Purchase_Freight_Taxable	Purchase Freight Taxable	Integer	DDL_Purchase_Tax_Options	0
72	Purchase_Misc_Taxable	Purchase Misc Taxable	Integer	DDL_Purchase_Tax_Options	0
73	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt Work'].FRTSCHID AS 'Purchasing Receipt Work-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt Work'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
74	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Purchasing Receipt Work'].MSCSCHID AS 'Purchasing Receipt Work-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Purchasing Receipt Work'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
75	FRTTXAMT	Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
76	ORFRTTAX	Originating Freight Tax Amount	Currency	DLR19_RBSO_UTR$	19
77	MSCTXAMT	Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
78	ORMSCTAX	Originating Misc Tax Amount	Currency	DLR19_RBSO_UTR$	19
79	BCKTXAMT	Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
80	OBTAXAMT	Originating Backout Tax Amount	Currency	DLR17_RBS0_UTR$	17
81	BackoutFreightTaxAmt	Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
82	OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	Currency	DLR17_RBS0_UTR$	17
83	BackoutMiscTaxAmt	Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
84	OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	Currency	DLR17_RBS0_UTR$	17
85	TaxInvReqd	Tax Invoice Required	Boolean	CB_Tax_Invoice_Required	0
86	TaxInvRecvd	Tax Invoice Received	Boolean	CB_Tax_Invoice_Received	0
87	APLYWITH	Apply Withholding	Boolean	Boolean	0
88	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
89	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['Purchasing Receipt Work'].SHIPMTHD AS 'Purchasing Receipt Work-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['Purchasing Receipt Work'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
90	DocPrinted	DocPrinted	Boolean	CB_DocPrinted	0
	Click to show/hide Document Printed flag 0 Record has not been printed. 1 Record has been printed.
91	Total_Landed_Cost_Amount	Total Landed Cost Amount	Currency	DLR17_RBS0_UTR$	17
92	BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
93	OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	DLR17_RBS0_UTR$	17
94	CBVAT	Cash Based VAT	Boolean	CB_CashBasedVAT	0
95	VADCDTRO	Vendor Address Code - Remit To	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['Purchasing Receipt Work'].VADCDTRO AS 'Purchasing Receipt Work-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM POP10300 AS ['Purchasing Receipt Work'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['Purchasing Receipt Work'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['Purchasing Receipt Work'].VENDORID = ['PM Address MSTR'].VENDORID
96	TEN99TYPE	1099 Type	Integer	1099_Type	0
97	TEN99BOXNUMBER	1099 Box Number	Integer	DDL_1099_Box	0
98	REPLACEGOODS	Replace Returned Goods	Boolean	CB_ReplaceReturnedGoods	0
99	INVOICEEXPECTED	Invoice Expected Returns	Boolean	CB_InvoiceExpectedReturns	0
100	PrepaymentAmount	Prepayment Amount	Currency	DLR19_RBS0_UTR$	19
101	OriginatingPrepaymentAmt	Originating Prepayment Amount	Currency	DLR19_RBS0_UTR$	19
102	POP_HDR_Errors_4	POP HDR Errors 4	Long Integer	ML_POP_HDR_Errors_4	0
103	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
104	ORDISTKN	Originating Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
105	DISAVTKN	Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
106	ORDATKN	Originating Discount Available Taken	Currency	DLR17_RBS0_UTR$	17
107	InvoiceReceiptDate	Invoice Receipt Date	Date	DT	8
	Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade.
108	Workflow_Status	Workflow Status	Integer	Workflow Status	0

azurecurve Products Microsoft Dynamics GP (0)PurchasingPurchasing Receipt Work (POP10300)

Leave a Reply Cancel reply